
delete  from loja_venda where data_venda='20011201'
go
delete from loja_venda_pgto where  data='20011201'
go
delete from loja_resumo_operacao where  data='20011201'
go
delete from loja_resumo_caixas where  data='20011201'
go
delete from loja_caixa_lancamentos  where  data='20011201'
go

select *  from loja_venda where data_venda='20030622' and CODIGO_FILIAL='02' and PERIODO_FECHAMENTO='02'
go
select * from loja_venda_pgto where  data='20030622' and CODIGO_FILIAL='02' and PERIODO_FECHAMENTO='02'
go
select * from loja_resumo_operacao where  data='20030622' and CODIGO_FILIAL='02' and PERIODO_FECHAMENTO='02'
go
select * from loja_resumo_caixas where  data='20030622' and CODIGO_FILIAL='02' and PERIODO_FECHAMENTO='02'
go
select * from loja_caixa_lancamentos  where  data='20030622' and CODIGO_FILIAL='02' and PERIODO_FECHAMENTO='02'
go